8.1
DECLARE @var_1 char(20),@var_2 int /**/ 
SET @var_1='Hello!' /*Ϊ@var_1ֵ*/
SELECT @var_2=10 /*Ϊ@var_2ֵ*/
SELECT @var_1,@var_2 /**/
8.2

8.3
SELECT * FROM Empoyees In Beijing 
Ϊ
SELECT * FROM [Empoyees In Beijing]
8.4
use myDB
go
IF EXISTS (SELECT kcName FROM COURSE WHERE kcName= 'ɢѧ')
   PRINT 'ɢѧſγ'
ELSE
   PRINT 'ûɢѧſγ̡'

8.5
USE myDB
GO
WHILE NOT EXISTS (SELECT gradeNum FROM grade where gradeNum>95)
  BEGIN
    IF (SELECT MAX(gradeNum) FROM grade)<95   
      UPDATE grade
      SET gradeNum=gradeNum*1.05
    ELSE
      BREAK
  END
select * FROM grade

8.6
USE myDB
GO
SELECT top 2 sName FROM student 
GO
--ӳʾʱ
WAITFOR DELAY '00:00:10'
SELECT top 2 sName,sZhuanye FROM student
GO

8.7
USE myDB
GO
SELECT sID,sName,sBanji 
FROM student 
WHERE SUBSTRING(sID,2,2)='03'

8.8
USE myDB
GO
SELECT sID ѧ,sName ,YEAR(GETDATE())-YEAR(sBirthday) ,sSex Ա 
FROM student

8.9
USE myDB
GO
SELECT ݿ= DB_NAME(),ǰ¼ıʶ=SUSER_NAME()

8.10
USE myDB
GO
CREATE FUNCTION Fn_Count_Grade
(@clsID  Char(6))
RETURNS  @Fn_Count_Grade TABLE
(γ Char(20) PRIMARY KEY NOT NULL,
ƽɼ  Decimal(6,2)  NOT  NULL
)
AS
 BEGIN
  INSERT @Fn_Count_Grade
   SELECT kcName as γ,AVG(gradeNum) AS ƽɼ
   FROM  grade inner join course on grade.kcID=course.kcID
   WHERE sID in(select sID from student where sBanji=@clsID) 
   GROUP BY kcName
 RETURN
END


USE myDB
GO
SELECT * FROM  dbo.Fn_Count_Grade ('Z0401')

СеT-SQL
SELECT kcName as γ,AVG(gradeNum) AS ƽɼ
FROM  grade inner join course on grade.kcID=course.kcID
WHERE sID in(select sID from student where sBanji='Z0401') 
GROUP BY kcName

8.11
USE myDB
GO
DECLARE cur_student cursor CURSOR 
FOR 
SELECT * FROM student
FOR READ ONLY

8.12
USE myDB 
GO 
DECLARE cur_Course_stuInfo CURSOR 
GLOBAL SCROLL DYNAMIC 
FOR 
SELECT sName,sZhuanYe,sRuxueshijian,gradeNum
FROM student inner JOIN grade ON student.sID=grade.sID
WHERE kcID='k008'

8.13
OPEN cur_Course_stuInfo 
SELECT @@CURSOR_ROWS as 'αcur_Course_stuInfo¼'

8.14
OPEN cur_Course_stuInfo  /*  α  */
FETCH NEXT FROM cur_Course_stuInfo /* һζȡõм¼ */
--ѭȡʣ
WHILE @@FETCH_STATUS=0 
  BEGIN
    FETCH NEXT FROM cur_Course_stuInfo
  END 
CLOSE cur_Course_stuInfo /* --رα */
DEALLOCATE cur_Course_stuInfo  /*  ͷ(ɾ)αcur_Course_stuInfo  */

